UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G8caK8+WxoGdMbcCKaX7zkmTrMuxIKXTBYJIF9puVYU='
WHERE
key_id = '89021c8531cba9a97f4a79e829ba6c99049c221b8028cde293b3dd0cab021aff'
AND (
token = 'G8caK8+WxoGdMbcCKaX7zkmTrMuxIKXTBYJIF9puVYU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)