UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ByZtTUes7mZERt1Wvl43lsV6N94eagO4uftTCxOMA+k='
WHERE
key_id = '6501658b29a356847063e7bc8e7156372b5081e3edf533d43a2e0659443f9f6e'
AND (
token = 'ByZtTUes7mZERt1Wvl43lsV6N94eagO4uftTCxOMA+k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)