UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Gr5snJHnjNcd6yq6Knl8mjSYd6lPVf1hePDkffeLmQI='
WHERE
key_id = 'de0847c86d468f7aeeac73e762d50b40e12b0b31b600ecec3fd96b6d1a8b2283'
AND (
token = 'Gr5snJHnjNcd6yq6Knl8mjSYd6lPVf1hePDkffeLmQI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)