UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0DvUZkGuW1Rzro0XRiQSaQ+eQpjlgTBOQEY0hrwIgew='
WHERE
key_id = '40b500864bccd53dceaf0d55a5715be54d2a74b1aaec758e2a5af144b8a21ef0'
AND (
token = '0DvUZkGuW1Rzro0XRiQSaQ+eQpjlgTBOQEY0hrwIgew='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)