UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mmsrmJP+PTxnMlYxefqEeSYgQXWwwAVbysKYeiiLAcw='
WHERE
key_id = 'bcc895ec1e9cd362d5879743e9786ef55fd914e834c4fe05f8a556be9e347a67'
AND (
token = 'mmsrmJP+PTxnMlYxefqEeSYgQXWwwAVbysKYeiiLAcw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)