UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8pk8UJp5KGGaXA78F4+pFXprRjnA6jb7bNGg4CIqQrs='
WHERE
key_id = 'f554cc6bb76c9bced4e544b087c7a0c9656e4d0ae2fd0ccfa9d817d1e9883f11'
AND (
token = '8pk8UJp5KGGaXA78F4+pFXprRjnA6jb7bNGg4CIqQrs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)