UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zydvj8oLr/ZE1HMKvkzrJPUvALDNceGDxmIpOZTAJ+Q='
WHERE
key_id = 'facdce3fdb4dfaaf5d2a528c905bd0a19d121bde6b598b9ac4b33ca5252dd901'
AND (
token = 'zydvj8oLr/ZE1HMKvkzrJPUvALDNceGDxmIpOZTAJ+Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)