UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/4OooNg86HrzZvyzEJXSPeoSf0FLQcnAMpP6LEvoSzs='
WHERE
key_id = '4726512339a0f0697ab2271a9485cdedb5ca12c6d5f03e897e5ebdf00f2b3797'
AND (
token = '/4OooNg86HrzZvyzEJXSPeoSf0FLQcnAMpP6LEvoSzs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)