UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zpHDNZ/Yz8HFTu0ZUbbRyNvvoyN7PGFTH4U0PLRpsik='
WHERE
key_id = '9d82391ffd1af38ffd7dc27eec3a4083727b2c75f3b8396f1cfb284e3021df30'
AND (
token = 'zpHDNZ/Yz8HFTu0ZUbbRyNvvoyN7PGFTH4U0PLRpsik='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)