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