UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1hnoha44a4LjqkO1g7iniedPM9gVZ91lGdx51i/X8+8='
WHERE
key_id = 'ed230774dee8a9489c99b8eb81552222f2a6ab123ab5a17b126a7e3e9e5c39ac'
AND (
token = '1hnoha44a4LjqkO1g7iniedPM9gVZ91lGdx51i/X8+8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)