UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rBH7dSuCrYjIMfZsZWJUx9C2rmRIWoTXsxGWNqbULBQ='
WHERE
key_id = '100bf8d719062a02baa38cccae7bf6f42ecd39030c70a2f5c3ae97d38723dd7f'
AND (
token = 'rBH7dSuCrYjIMfZsZWJUx9C2rmRIWoTXsxGWNqbULBQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)