UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cCbmg6ESThP1Zb8kZbgEpl4v4vZLdGhwoNWdvevXRog='
WHERE
key_id = 'e0a1f39ed686529747bd18e1b597edcd4b6d09746203713d644149053f0a5c8e'
AND (
token = 'cCbmg6ESThP1Zb8kZbgEpl4v4vZLdGhwoNWdvevXRog='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)