UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QO7ByjgmsSJHqqlG5pU46DUnqKfzZirblHqA8Lau4Bo='
WHERE
key_id = '9a54b6dec77bea9da789745c32515ab9c5f50e79435adadf3f953486823b5a9a'
AND (
token = 'QO7ByjgmsSJHqqlG5pU46DUnqKfzZirblHqA8Lau4Bo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)