UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Qa9tfII1ulmHOjnBlia3/grANeQO5lxi9ifquyGemzI='
WHERE
key_id = '0effd7f61b7d3f86ea6886062a2e6b9748580897889d70545c3dfa9dee7f998b'
AND (
token = 'Qa9tfII1ulmHOjnBlia3/grANeQO5lxi9ifquyGemzI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)