UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mNuVouoiFhcHpCCOC+eJe6oUnYShqnEGe8P2AZhCTnQ='
WHERE
key_id = 'e6ed924e6d89ce8ac3c93fcc5c5a8720f8bc144ac302355814770e9e8e2e33a8'
AND (
token = 'mNuVouoiFhcHpCCOC+eJe6oUnYShqnEGe8P2AZhCTnQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)