UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GihFXZRdSYCRxjYtw31f7hpUrkCL6u7MP/ig8e0A5GI='
WHERE
key_id = '78afd5ba48ee95ac9bfa919fd675c964493273aff7619a3d9e5218f0efdb2527'
AND (
token = 'GihFXZRdSYCRxjYtw31f7hpUrkCL6u7MP/ig8e0A5GI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)