UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WUWyXhTaGhIsCUk2bV7fN74xAdCobHdWhHI6PZ++9+Y='
WHERE
key_id = 'b7067ad7d0496641c77f3fd5612488c0462d3f06369d93cd199dfb70934b217f'
AND (
token = 'WUWyXhTaGhIsCUk2bV7fN74xAdCobHdWhHI6PZ++9+Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)