UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '31I8lsAkWZSuCB1NDT42M42C6fDGVoWFNNtIOxUCahw='
WHERE
key_id = 'b19f1d54464081a7e199ffac5c5f4f38b96984a04f4a889ec108c66801d76779'
AND (
token = '31I8lsAkWZSuCB1NDT42M42C6fDGVoWFNNtIOxUCahw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)