UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZT1k8tzEqgG2TP6EKfmGJ3gGzfiHKV3WETRfrl92YTQ='
WHERE
key_id = '407a6ebfa09ee99f347514da1730a84fc4581f918e34a6853d84bdd30561f6bb'
AND (
token = 'ZT1k8tzEqgG2TP6EKfmGJ3gGzfiHKV3WETRfrl92YTQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)