UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yIczedjbb0Wd6/rX/44zXlEQfYEIO2eE28u/A995Q8Y='
WHERE
key_id = '295181e82bf4fe8e714a264f9b552ee71de9670a13e17c340eb976a3b4fd0497'
AND (
token = 'yIczedjbb0Wd6/rX/44zXlEQfYEIO2eE28u/A995Q8Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)