UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4SCcUNRM4gCU4gTB/gS0jnNZmDbU7+OoIh5hkrd5TSY='
WHERE
key_id = '397e96792499153ff01ce24e162f69e26828b0fc870d1674620db196f8c4f24a'
AND (
token = '4SCcUNRM4gCU4gTB/gS0jnNZmDbU7+OoIh5hkrd5TSY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)