UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '55gE4ig76huEXd4ARAArTdKECX0EiWBth07nuoVQUqA='
WHERE
key_id = '96dea00f53ea8c25424174f0e89b63402a51e5a29437e30f8f70d9b3c1d1cd28'
AND (
token = '55gE4ig76huEXd4ARAArTdKECX0EiWBth07nuoVQUqA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)