UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XJBfhI8nGn1QfRL7KbNNpDsojsWYesrClt//WPZam28='
WHERE
key_id = '794c1cc8e2a1130ba058eabd26d116655b7796718561e4788291634260950e8e'
AND (
token = 'XJBfhI8nGn1QfRL7KbNNpDsojsWYesrClt//WPZam28='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)