UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PtsSOcbZErlkOpmXxV2n3KliM2LKZS3fRVy9G0m2Hws='
WHERE
key_id = 'e79a9bb773f61a15a7288b4d26ff8c7ba2ab1797fb473980ca535dc168bbf6b4'
AND (
token = 'PtsSOcbZErlkOpmXxV2n3KliM2LKZS3fRVy9G0m2Hws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)