UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'md+C+PK9we4GeP9GOlCWCT1yMS8ebt++/qkiOZNuWUs='
WHERE
key_id = '21cf7094bc3a5e1c92c41edfad788f9604de1970a6f192bef782a1bce2957040'
AND (
token = 'md+C+PK9we4GeP9GOlCWCT1yMS8ebt++/qkiOZNuWUs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)