UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sXympH/1KM0t0swGxu18XaY8nkN8ck8NrZ6IRtrwHkg='
WHERE
key_id = 'be7cd9c02f905cc15941e28f983f5f960314a9195841d821fd3c5b2c408f573f'
AND (
token = 'sXympH/1KM0t0swGxu18XaY8nkN8ck8NrZ6IRtrwHkg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)