UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IxlK28LU7HydIATSHZTch/xPrQKNZUwIY9vAOUKRV9Q='
WHERE
key_id = '931f92a8d3e0d44a66cfccc107abcd90068d9ab95f692ee87c80b753e9bc37ba'
AND (
token = 'IxlK28LU7HydIATSHZTch/xPrQKNZUwIY9vAOUKRV9Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)