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