UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KBxtxKSMW5YUc6BneE6xmIZjptPCLRb/qMIzlVar54Y='
WHERE
key_id = '7b53f12c15d3758b07f06e40fef8fe0f9e2d9d19f84d143e11e9c46459b3e58f'
AND (
token = 'KBxtxKSMW5YUc6BneE6xmIZjptPCLRb/qMIzlVar54Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)