UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vIMiWKti+m8owI4kIMmvYEPe9G34Ruo2w2LwUwa2yF8='
WHERE
key_id = 'ff0da5487f77efc5e55a64f3164968442bb2f2e54acede00d389eeadfb9facbb'
AND (
token = 'vIMiWKti+m8owI4kIMmvYEPe9G34Ruo2w2LwUwa2yF8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)