UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xD4AXw8TARsBtXFllr1KckGXoOZ1FEKR6njiaL5cXoY='
WHERE
key_id = '0498cda65d24407dc7123e973bee09c50075c3925dd91dba085a09026982df10'
AND (
token = 'xD4AXw8TARsBtXFllr1KckGXoOZ1FEKR6njiaL5cXoY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)