UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KpBWm7RHxbokL1EG26eVMba5NDBAuMrZF2zqKpHzU2M='
WHERE
key_id = '949cd59792db0f78b05647b6ed9ba3a29aa0d7360b5e05187a789b3f2ec2a48a'
AND (
token = 'KpBWm7RHxbokL1EG26eVMba5NDBAuMrZF2zqKpHzU2M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)