UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZZ7OzbtxHzfRvysvG/X2pDycV0oU63NiEROC135HdxA='
WHERE
key_id = '5c8a0efa1fc4901fe2c79a1968bea1c49302d77a6f3437b4eae8b0f79cf59293'
AND (
token = 'ZZ7OzbtxHzfRvysvG/X2pDycV0oU63NiEROC135HdxA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)